package com.qdu.service;

import java.util.List;


import org.apache.ibatis.annotations.Param;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;

import com.qdu.entity.Student;

public interface StudentService {

	Student selectStudentById(String id);

	boolean addStudent(@Param("Student") Student Student, @Param("bid") int bid);

	boolean modifyStudent(@Param("Student") Student Student, @Param("bid") int bid);

	boolean deleteStudentById(String id);

	List<Student> selectAllStudent();

	List<Student> selectAllStudentByBid(int bid);

	XSSFWorkbook showStudentByBid(int bid);

	boolean uploadStudent(MultipartFile file) throws Exception;
	
	List<Student> selectStudentByKeyWord(String keyword);
}
